3fa301590e19119d17efda9706200305496230f3,portal-impl/src/com/liferay/portal/verify/VerifyCalendar.java,VerifyCalendar,verifyRecurrence,#,105

Before Change


		try {
			con = DataAccess.getUpgradeOptimizedConnection();

			String sql = SQLTransformer.transform(
				"select eventId, recurrence from CalEvent where (CAST_TEXT(" +
					"recurrence) != '') and recurrence not like " +
						"'%serializable%'");

			ps = con.prepareStatement(sql);

			rs = ps.executeQuery();

After Change


		ResultSet rs = null;

		try {
			con = DataAccess.getUpgradeOptimizedConnection();

			ps = con.prepareStatement(
				"select eventId, recurrence from CalEvent where (CAST_TEXT(" +
					"recurrence) != '') and recurrence not like " +
						"'%serializable%'");

			rs = ps.executeQuery();